L03-05-Part 1 Ingesting At Scale- Use COPY
Which method is faster for ingesting data in a sql database?
Insertion using the INSERT command record by record in for loop
Bulk insertion using the COPY command
Why do we split a table into multiple files before ingestion?
Because this way, we can execute multiple simultaneous COPY commands
Because S3 can not handle the copying of one large file
Next Concept